Project Summary
Goodcabs, a cab service company established two years ago, has been expanding its operations in tier-2 cities across India. Unlike many competitors, Goodcabs focuses on empowering local drivers, enabling them to earn a stable income while providing quality transportation services. With operations in 10 tier-2 cities, the company has set ambitious performance targets for 2024, emphasizing growth and customer satisfaction.Objectives of the Analysis
The primary goal of this project was to assess Goodcab's performance across key business metrics, enabling data-driven decision-making.The focus was on:
1. Trip Volume Analysis – Understanding the total number of trips and trends over time.
2. Passenger Satisfaction – Measuring rider feedback and service quality.
3. Repeat Passenger Rate – Identifying loyal customers and retention trends.
4. Trip Distribution Across Cities – Analyzing trip frequency by location to optimize operations.
5. New vs. Repeat Passengers – Understanding customer behavior to refine marketing and service strategies.
Insights & Business Impact
📈 Growth Trends → Identified peak and low-demand months to optimize fleet management.🏙️ City Performance → Pinpointed cities with the highest and lowest trip volumes.
🔄 Customer Retention → Determined factors affecting repeat passenger rates.
⭐ Service Quality → Highlighted areas where driver performance & rider experience could improve.
Why This Project is Valuable?
✅ Demonstrates Real-World Business Problem Solving✅ Showcases Power BI Skills – Data Cleaning, Modeling, and Visualization
✅ Applies Advanced DAX for KPI Calculation
✅ Provides Actionable Insights for Business Strategy
Let's see the project and explore all its objectives and insights.
Power BI Report :